Recent

Author Topic: Database  (Read 284 times)

amedeo

  • New Member
  • *
  • Posts: 12
Database
« on: November 23, 2020, 11:41:01 am »
Hy people
my be this is a stupid question but I d'nt find a answer  :'(  :
how to write a SQL string to find all the records of a table containing a sub-string in a field?
Thanks
amedeo

dseligo

  • New Member
  • *
  • Posts: 37
Re: Database
« Reply #1 on: November 23, 2020, 12:10:03 pm »
Code: Pascal  [Select][+][-]
  1. select *
  2. from mytable
  3. where myfield like '%search_string%'

amedeo

  • New Member
  • *
  • Posts: 12
Re: Database
« Reply #2 on: November 23, 2020, 12:26:53 pm »
Great, a lot of thanks
Amedeo

 

TinyPortal © 2005-2018