mercredi 22 avril 2015

Combining like clause's - A special wildcard and a column

Im trying to do a select statement that querys my comments column for all data that includes @"username" in a database table. For example if i wanted to find @bobby. The query would search for wildcard @ in combination with checking each element in the username column. e.g username column is

**USERNAME** 
bobby
foo
patrick

This is what I have so far ( I know its wrong but you get the idea what I am trying to achieve )

 "SELECT * FROM posts WHERE content LIKE '%@%' AND content LIKE "entire usename column""

Aucun commentaire:

Enregistrer un commentaire