Not Found Message

[Dysan]

Hi, How do I search the database for the name "Simon"?
Then, if it exists output "Exists". If it doesn't exist, output "Not Found"?

[bpat1434]

You want to use the SQL "LIKE" keyword or "MATCHES".

Please see: Full Text Searches

alternatively, if you're doing username type stuff, you can just say:

"WHERE username = 'Simon'"

If a row is returned, it exists, if not, then it's not found.