devxlogo

Wildcard Searches in SQL

Wildcard Searches in SQL

Question:
Are wildcards allowed when trying to matchthe contents of a textfield as in the following example?

    SELECT * FROM Database WHERE textfield = ‘B*’

Answer:
Yes, but you’ll need to use the LIKE clause instead ofthe equal sign, and the wildcard character in SQL is thepercent sign. Your correct syntax will be:

    SELECT * FROM Database WHERE textfield LIKE ‘B%’;

devx-admin

Share the Post: