Search database

[this.user]

how do i search a table row, lets say Names for any names that do not start with any letter a-zA-Z?

 

also is LIKE the best use for this type of searhc?

[dgoosens]

have a look at regular expressions

http://dev.mysql.com/doc/refman/5.1/en/regexp.html

 

something like:

SELECT column FROM table

WHERE column REGEXP '^[[:alpha:]]'

[sohaibshaheen]

how do i search a table row, lets say Names for any names that do not start with any letter a-zA-Z?

 

also is LIKE the best use for this type of searhc?

 

This is what you exactly need!!

 

 

$result = mysql_query(" SELECT * FROM table WHERE column NOT REGEXP '^[a-z]'  ") 
					or die(mysql_error()); 

 

If I am not wrong! As far as I tested this is case insensitive match so a-z and A-Z are same!

[dgoosens]

If I am not wrong! As far as I tested this is case insensitive match so a-z and A-Z are same!

 

This depends on the table and its collation:

http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html