SQL for filtering records with part of value is same -


i don't have expertise in sql. want filter records table below criteria.

i want separate out records in below example result showing "klmnp03" , "uvxyz03". there similar records last chars 03 , 04, want filter out records 03 @ end

for example:

col1 --------- abcde03 abcde04 klmnp03 lmnop03 lmnop04 uvxyz03 

i'm not sure use case is, pretty inefficient. it's better use whole columns. in case, asking for:

select  *    yourtable   col1 not ( '%03' ) 

this return not have 03 @ end.

% wild card character, , represents number of characters before normal characters. can similar _ character, represents single random character.

in sqlserver @ least. may different in other rdbms


Comments

Popular posts from this blog

Ansible - ERROR! the field 'hosts' is required but was not set -

customize file_field button ruby on rails -

SoapUI on windows 10 - high DPI/4K scaling issue -