CodingForums
درباره سایت
آخرین مطالب
- QQSLOT LINK DAFTAR WEBSITE DAPET BONUS DI AWAL
- QQSLOT Situs QQ Dijamin WD Besar
- Belajar Pemrograman Komputer dengan Yang Terbaik - Pelajari cara membuat program bersama kami, di sini Anda dapat mempelajari cara membuat halaman web yang indah menggunakan HTML dan CSS.
- RankMonarch - Jasa Full-Stack Digital Marketing Segala Niche
- Copy a Button?
- Centering Text
- ^EQ and selecting multiple items
- Search in a multidimensional array and get the key?
- How do i pass form vaues to javascript window.open.
- Flexbox postioning
امکانات وب
Hi,
I have table with id, refpost, type and comment fields. The comment field type is TEXT.
I need to get rows where refpost which has type='A' or type='D', which appear in comment field.
I tried this query:
But without result and i get error message: 1242: Subquery returns more than 1 row
This my table.
I have table with id, refpost, type and comment fields. The comment field type is TEXT.
I need to get rows where refpost which has type='A' or type='D', which appear in comment field.
I tried this query:
Code:
SELECT id, refpost, type, comment
FROM table
WHERE comment
LIKE
(
SELECT refpost
FROM table
WHERE type='A'
OR type='D'
)This my table.
برچسب:
نویسنده: آیلین رضوانی