Recent

« previous next »
Pages: [1]

Author Topic: Database  (Read 788 times)

amedeo

  • New Member
  • *
  • Posts: 35
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
Logged

dseligo

  • Hero Member
  • *****
  • Posts: 1219
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%'
Logged

amedeo

  • New Member
  • *
  • Posts: 35
Re: Database
« Reply #2 on: November 23, 2020, 12:26:53 pm »
Great, a lot of thanks
Amedeo
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018