Mariadb: Need help querying multiple WHERE LIKE conditions

[Malcolm]

Hi folks,

I'm trying to query values that match certain conditions using Mariadb.
Currently, I have a WHERE statement with: WHERE value LIKE "value1" OR LIKE "value2"; however, after running, I get an error stating there's an error with my syntax (I may be confusing MySQL syntax, which is probably why).

What would be the correct way to use this statement WHERE value LIKE "value1" OR LIKE "value2" in Mariadb?

Any help would be much appreciated! :0

 

[Malcolm]

I see what I did wrong. I'm missing the column name in my second condition. The correct way of doing this is WHERE value LIKE "value1" OR value LIKE "value2"

Also, removed the `AND`s because I meant to use OR.

 

[charlotte]

I'm trying to query values that match certain conditions using Mariadb.
Currently, I have a WHERE statement with: WHERE value LIKE "value1" OR LIKE "value2"; however, after running, I get an error stating there's an error with my syntax (I may be confusing MySQL syntax, which is probably why).

What would be the correct way to use this statement WHERE value LIKE "value1" OR LIKE "value2" in Mariadb?

To query multiple conditions using the LIKE operator in MariaDB, you should list each condition separately within the WHERE clause. Here's how you can do it:

WHERE value LIKE 'value1' OR value LIKE 'value2';

This will retrieve rows where the value matches either 'value1' or 'value2'. Make sure to use single quotes for string literals in SQL queries.

Let me know if you need more help or clarification!

 

[menator01]

The docs on the mariadb like clause

LIKE

Whether expression matches a pattern.

mariadb.com

 

[Malcolm]

To query multiple conditions using the LIKE operator in MariaDB, you should list each condition separately within the WHERE clause. Here's how you can do it:

WHERE value LIKE 'value1' OR value LIKE 'value2';

This will retrieve rows where the value matches either 'value1' or 'value2'. Make sure to use single quotes for string literals in SQL queries.

Let me know if you need more help or clarification!

Thank you! Much appropriated.

 

[Malcolm]

The docs on the mariadb like clause

LIKE

Whether expression matches a pattern.

mariadb.com

I tried looking into the docs but wasn't able to find the information about multiple conditions. Did I miss it somewhere in the docs?