MySQL Wildcard for "=" - is there one

mysql wildcard
Dan picture Dan · Apr 29, 2009 · Viewed 25.1k times · Source

So,

SELECT * FROM table WHERE col LIKE '%'

will return everything. Is there a wildcard for the query 

SELECT * FROM table WHERE col = '*'

Clearly * doesn't work, I just put it there to indicate where I'd like a wildcard. The column I'm selecting from contains an integer between 1 and 12, and I want to be able to select either all records with a particular number, or all records with a wildcard.

Thanks,

Answer

zombat picture zombat · Apr 29, 2009

LIKE is basically the same as =, except LIKE lets you use wildcards.

These two queries will return the same results:

SELECT * FROM table WHERE col LIKE 'xyz';
SELECT * FROM table WHERE col='xyz';

Without a '%' in the LIKE query, it is effectively the same as '='.

If you're doing a selection on an integer column, you should consider using the IN() or BETWEEN operators. It sounds like you have two separate conditions that should be handled in your code however, rather than in the query, as your conditions dictate that you need at least two different kinds of queries.

Edit: I should clarify that LIKE and = are similar only in normal, humdrum string comparison usage. You should check the MySQL Manual for specifics on how it works, as there are situations where it's not the same (such as language sets).

Related questions

Select all columns except one in MySQL?

I'm trying to use a select statement to get all of the columns from a certain MySQL table except one. Is there a simple way to do this? EDIT: There are 53 columns in this table (NOT MY DESIGN)

Read More
Selecting all columns that start with XXX using a wildcard?

I have several columns in my databases with similar names. How do I select those based on the word they start with? Here's an example table layout: I tried selecting all info for a particular thing (food kind in this …

Read More
Why does "_" (underscore) match "-" (hyphen)?

I have to look for a PDF manual using this query: root@localhost:test> select * from a where name like '%taz_manual%.pdf%'; +--------------------+------------------+-------------+ | name | description | size | +--------------------+------------------+-------------+ | taz-manual-1.1.pdf | Manual v1.0 TA-Z | 31351902 | | …

Read More