there is a problem. What should I do if I want to take a record that matches multiple characters in a field?
select *
from actor
where last_name like ("% DAVI%","MOSTEL%","ABC","kkk%aa")
the above sql statement is incorrect. Like does not support multiple strings. How can it be implemented?
Thank you
concatenate with OR, where last_name like'% DAVI%' OR last_name like 'MOSTEL%' OR.
if there is not much patterns, use
last_name LIKE patt1 OR last_name LIKE patt2 .... If you have a lot of patterns, you can store patterns in a table patterns (pat) , and then:
if you are using oracle, you can use regular functions, regexp_like
background: 1. I am a java programmer 2. Recently interviewed for a senior development position 3. The previous project mainly used less oracle,mysql, and the companies interviewed basically used mysql s 4. I am weak in the database 5. Recently, I...
is there any way? such as recommended books, blogs, etc. ...
1. If you use select * from APowerB without any conditions, the result will be displayed associated with tables an and b, but the result will be repeated many times 2, and select * from a join b, will not add any query conditions, and the result will b...
select regexp_replace (regexp_replace) Yu 0min Za , , ), [ u4e00 - u9fa5. The running result of ORACLE ORACLE] {1,} , U4e00 - u9fa5. The result of Yu Minli GP running:?? The result of HIVE running in Yu 0 min Za:? 0Za Why are the res...
as mentioned above, I want to count the number of records in the database. If a field is required to repeat, the count is 0. For example: a database of car sales invoices, in which there is a frame number field referred to as CJHM. I want to count the n...
use leftJoin multi-table join lookup. Finally, a field in select is a field from count in one of the right tables, but if there is no count data in that table, the entire query will lose the result. Now you want to keep the data in the left table if the...