Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
Database
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
How can i make this windo...
by
majid.ebru
[
Today
at 03:58:18 pm]
Does anyone know why this...
by
Laksen
[
Today
at 03:34:38 pm]
pre-processor symbol when...
by
Thaddy
[
Today
at 03:22:40 pm]
CORBA interface and Varia...
by
marcov
[
Today
at 03:11:07 pm]
Values of a custom compon...
by
CM630
[
Today
at 01:42:08 pm]
For-in loop over constant...
by
TRon
[
Today
at 01:37:56 pm]
Arabic text, problem on L...
by
marius.maximus
[
Today
at 12:59:47 pm]
[solved] Lazarus does not...
by
wp
[
Today
at 12:38:09 pm]
How does Castle Game Eng...
by
Aistis
[
Today
at 12:21:03 pm]
CocoaInt.CocoaIconUse no ...
by
MISV
[
Today
at 11:51:28 am]
Minimum code for implemen...
by
MISV
[
Today
at 11:37:54 am]
How are cookies share Web...
by
MISV
[
Today
at 11:22:51 am]
[re-opened] Package PPU l...
by
CCRDude
[
Today
at 11:19:11 am]
Distro has depreciated qt...
by
TheMouseAUS
[
Today
at 11:12:25 am]
How can I draw a rectangl...
by
jcmontherock
[
Today
at 11:08:24 am]
TBGRABitmap.TextSize retu...
by
KodeZwerg
[
Today
at 10:26:36 am]
Lazreport: Question about...
by
teco
[
Today
at 09:18:07 am]
how to using CryptoLib4Pa...
by
paweld
[
Today
at 07:59:04 am]
How to: create DLL file f...
by
paule32
[
Today
at 07:03:32 am]
[solved]FP IDE(FP.exe) fa...
by
gasensor
[
Today
at 03:00:19 am]
ThumbControl : how to loa...
by
the_magik_mushroom
[
Today
at 01:48:57 am]
[solved] Iteration of cla...
by
Joanna
[
Today
at 01:45:47 am]
leetcode doesn’t support ...
by
Joanna
[
Today
at 01:18:56 am]
Demoscene Square dot flag...
by
TRon
[
Today
at 01:10:22 am]
How to use the Event Log?
by
piola
[
Today
at 12:18:19 am]
« previous
next »
Print
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]
[+]
[-]
select
*
from mytable
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
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
Database
TinyPortal
© 2005-2018