what does # do in mysql string ?
I am trying to find the next entry in one of the fields in my table after an entry with '#3' (without quotes) in it. But it keeps returning some other entry in the table and not the one after '#3'
I feel it is something to do with the # but can not find anything on it.
This is the sort of query i am using..
Does the # do something with my string ?
SELECT * FROM `mytable` WHERE `myfield` > '" . $mysqli->real_escape_string($string) . "' ORDER BY `myfield` ASC LIMIT 1