<div>
I understand length<br />
SELECT LENGTH('text');<br />
<a href="http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_length" rel="ugc">http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_length</a><br />
<br />
<br />
but do not understand how to do conditional statement<br />
<br />
<br />
the if in php would be too complex<br />
I would rather do in mysql so I can test in query editor
</div>


I understand length
SELECT LENGTH('text');
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_length [http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_length]


but do not understand how to do conditional statement


the if in php would be too complex
I would rather do in mysql so I can test in query editor

<div>
the former introduced length and the latter applied length and a conditional statement to a sample query. Thank you.
</div>


the former introduced length and the latter applied length and a conditional statement to a sample query. Thank you.

<div>
<div class="content wysiwyg-content">
using php to update $new_input to varchar column<br />
<br />
if $new_input is empty do not update<br />
<br />
<br />
this has to be writen in mysql not php
</div>
</div>


using php to update $new_input to varchar column

if $new_input is empty do not update


this has to be writen in mysql not php

if $new_input is empty do not update

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.