Re: Write IF condition in Query , and mysql Search function

bharani kumar wrote: Hi All , Am working on the autosuggestion program SELECT $field2,$field1 FROM $tblname where locate('$q', $field2) > 0 OR locate('$q', $field1) > 0 order by locate('$q', $field2), $field2 limit " . ($pagesize * $page) . "," . $pagesize This is my query , Example

Write IF condition in Query , and mysql Search function

Hi All , Am working on the autosuggestion program SELECT $field2,$field1 FROM $tblname where locate('$q', $field2) > 0 OR locate('$q', $field1) > 0 order by locate('$q', $field2), $field2 limit " . ($pagesize * $page) . "," . $pagesize This is my query , Example in my Database tab