Results 1 to 6 of 6
Thread: varchar(), Firebird
Hybrid View
-
16th December 2012 23:07 #1
varchar(), Firebird
Firebird , , :
--
:
----
- .
SQL , , , varchar() ?
-
16th December 2012 23:57 #2
-
. , 2 , -.Code:update tablename set myfield=replace(myfield,' ',' ')
Last edited by tedych; 17th December 2012 at 00:19.
-
17th December 2012 01:36 #3
-
17th December 2012 13:21 #4
tedych - / 3 , 4 , /
2 , - , , .
SELECT * from TABLENAME where myfield LIKE '%--%'ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1
-
17th December 2012 18:12 #5
:
3 , :Code:select * from TABLE_NAME where FIELD_NAME like '% %'
, o.k.Code:update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ' ', ' ')
, :
Code:while ((select count(ID) from TABLE_NAME where FIELD_NAME like '% %') > 0) do UPDATE TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ' ', ' ')
-
17th December 2012 20:48 #6
, (php, perl ..) .
, . 3-4-5 , hateras
.




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in