Re: Need SQL help

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

SELECT * FROM MYTABLE1 WHERE
    LOCATE_IN_STRING(
                     FIELD1,
                     (SELECT FLDA FROM MYTABLE2)
                    ) > 0

On 12/10/2024 2:25 PM, Vinay Gavankar wrote:
> I have a Table (MYTABLE1) with millions of rows with a field FLD1 (256
> chars). I have another table (MYTABLE2) with about 100 rows with a field
> FLDA (15 chars).
>
> I want to get all records from MYTABLE1 where FLD1 has FLDA.
> If FLDA has a value of 'ABCD' then
> Select * from MYTABLE1 where FLD1 like %ABCD%
> would probably do the job. But I need to do it for FLDA values of all the
> records in MYTABLE2.
>
> I know I haven't explained it properly so let me give an example:
>
> FIELD1 in MYTABLE1:
> Row 1 - ABCDEF;123456;GH;78
> Row 2 - CDEFG;345678;
> Row 3 - 345678;EWRT;9888
> Row 4 - 85465;ASDFGT;QWERTY;85656
>
> FLDA in MYTABLE2:
> Row 1 - 123456
> Row 2 - 345678
>
> The final sql should return  Rows 1,2,3 from MYTABLE1.
>
> TIA
> Vinay